速報APP / 教育 / Learn MS Excel Assistant

Learn MS Excel Assistant

價格:免費

更新日期:2018-09-09

檔案大小:14M

目前版本:1.0

版本需求:Android 4.0 以上版本

官方網站:mailto:usrealtime.app@gmail.com

Email:http://worldsbestapps.blogspot.com/2018/09/learn-ms-excel-assistant.html

Learn MS Excel Assistant(圖1)-速報App

ADVANCED FILE TASKS -MS EXCEL

1. Saving and File Management

2. Converting and Encrypting Files

3. File Properties and Digital Signatures

4. File Accessibility and Compatibility

WORKING WITH FUNCTIONS AND FORMULAS

1. Working with Named Ranges 2. Array Functions (SUMIF & AVERAGEIF)

3. Formula Auditing

4. Formulas with Absolute References

Learn MS Excel Assistant(圖2)-速報App

5. Text Functions

6. Financial Functions

MANAGING TABLES IN MS EXCEL

1. Creating MS EXCEL Tables

2. Working with Records and Filters

3. Advanced Filters

ADVANCED FUNCTIONS IN MS EXCEL

1. Using Error Functions

2. Using Logical Functions

Learn MS Excel Assistant(圖3)-速報App

3. Using Array Formulas

4. Using Rounding Functions

DATA TOOLS IN MS EXCEL

1. Text to Columns

2. Flash Fill

3. Remove Duplicates

4. Data Validation

5. Consolidate

6. Sparkline

Learn MS Excel Assistant(圖4)-速報App

GROUPING & OUTLINING AND SUBTOTALS

1. Outlining and Grouping Data

2. Using the Subtotals Tool

WHAT-IF ANALYSIS

1. Exploring Scenarios

2. Goal Seek and Data Tables

3. Using Solver

ADVANCED PIVOT TABLES & CHARTS

1. Getting Started with Pivot Tables

Learn MS Excel Assistant(圖5)-速報App

2. Formatting a PivotTable

3. Using the Classic PivotTable Layout

4. Formatting a PivotChart

5. Calculated Fields in Pivot Tables

6. Showing Pivot Data as a Percentage

7. Creating Custom Pivot Tables Styles

8. Slicers

ADVANCED MS EXCEL TASKS

1. MS EXCEL and Hyperlinks

Learn MS Excel Assistant(圖6)-速報App

2. Using Custom AutoFill Lists

3. Sharing Workbooks

CREATING HLOOKUP AND VLOOKUP FUNCTIONS

1. Using the VLOOKUP Function

2. Using the HLOOKUP Function

ADVANCED CONDITIONAL FORMATTING

1. Editing Standard Formatting Rules

2. Using Formulas in Conditional Formatting

ADVANCED LOOKUP FUNCTIONS

Learn MS Excel Assistant(圖7)-速報App

1. Using the Index Function

2. Using the Match Function Using

3. Index and Match Together

4. Using Index and Match with Array

5. Formula Using the Indirect Function

Learn MS Excel Assistant(圖8)-速報App